package com.ruoyi.system.mapper;

import java.util.List;
import java.util.Map;

import com.ruoyi.system.domain.Renwu;
import org.apache.ibatis.annotations.Param;

/**
 * 【请填写功能名称】Mapper接口
 * 
 * @author ruoyi
 * @date 2024-06-19
 */
public interface RenwuMapper 
{
    /**
     * 查询【请填写功能名称】
     * 
     * @param renwuid 【请填写功能名称】主键
     * @return 【请填写功能名称】
     */
    public Renwu selectRenwuByRenwuid(String renwuid);

    public List<Map<String,Object>> existShenhezhongShiwuByZhuanjiaId (@Param("zhuanjiaid")String ppZhuanjiaId);

    Object getMaxOrdernumByShiwuId(@Param("shiwuid") String pp事务id);
    /**
     * 查询【请填写功能名称】列表
     * 
     * @param renwu 【请填写功能名称】
     * @return 【请填写功能名称】集合
     */
    public List<Renwu> selectRenwuList(Renwu renwu);

    /**
     * 新增【请填写功能名称】
     * 
     * @param renwu 【请填写功能名称】
     * @return 结果
     */
    public int insertRenwu(Renwu renwu);

    /**
     * 修改【请填写功能名称】
     * 
     * @param renwu 【请填写功能名称】
     * @return 结果
     */
    public int updateRenwu(Renwu renwu);

    /**
     * 删除【请填写功能名称】
     * 
     * @param renwuid 【请填写功能名称】主键
     * @return 结果
     */
    public int deleteRenwuByRenwuid(String renwuid);

    /**
     * 批量删除【请填写功能名称】
     * 
     * @param renwuids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteRenwuByRenwuids(String[] renwuids);

    public List<Map<String,Object>> findBdShenheListByDept(@Param("shenpideptid")String shenpideptid,
                                                         @Param("shifoutongguo")int shifoutongguo,
                                                         @Param("shifouwancheng")int shifouwancheng,
                                                         @Param("biandongleixing")String biandongleixing,
                                                         @Param("deptname")String deptname,
                                                         @Param("xingming")String xingming,
                                                         @Param("xiafashijiankaishi")String xiafashijiankaishi,
                                                         @Param("xiafashijianjieshu")String xiafashijianjieshu,
                                                         @Param("wanchengshijiankaishi")String wanchengshijiankaishi,
                                                         @Param("wanchengshijianjieshu")String wanchengshijianjieshu,
                                                         @Param("startindex")int ppStartIndex,
                                                         @Param("pagesize")int ppPageSize);

    int countBdShenheListByDept(@Param("shenpideptid")String shenpideptid,
                                @Param("shifoutongguo")int shifoutongguo,
                                @Param("shifouwancheng")int shifouwancheng,
                                @Param("biandongleixing")String biandongleixing,
                                @Param("deptname")String deptname,
                                @Param("xingming")String xingming,
                                @Param("xiafashijiankaishi")String xiafashijiankaishi,
                                @Param("xiafashijianjieshu")String xiafashijianjieshu,
                                @Param("wanchengshijiankaishi")String wanchengshijiankaishi,
                                @Param("wanchengshijianjieshu")String wanchengshijianjieshu);

    public List<Map<String,Object>> findspjl(@Param("shiwuid")String shiwuid);

    // 查询正常的专家
    public List<Map<String,Object>> findzhengchangzhuanjia(@Param("jieshutime")String jieshutime,@Param("picikaishimonth")String picikaishimonth);

    Object getMinKaishiNY(@Param("piciid") String piciid);

    Object getMinKaishimouth(@Param("piciid") String piciid);


    Object getMAxJieshumouth(@Param("piciid") String piciid);

    // 查询指定时间内的变动
    public List<Map<String,Object>> findBiandongByJieshuTime(@Param("jieshutime")String jieshutime,@Param("jiezhimonthlastday")String jiezhimonthlastday);

    // 存在审核变动 但是时间不在本批次内
    public List<Map<String,Object>> findCQBiandongByJieshuTime(@Param("jiezhimonthlastday")String jiezhimonthlastday);

    public List<Map<String,Object>> findNEWBiandongByJieshuTime(@Param("deptid")String deptid,@Param("zjzxjieshutime")String zjzxjieshutime,@Param("deptjieshutime")String deptjieshutime);
}
